<?php
    // Created By : Noan Babao
    // B.S. Computer Science - De La Salle Canlubang
    // September 28, 2011

    // IN: origin
    // OUT: Tagged by user Main document list 

// Start - Checker for those users who will just go to the page by typing directly in the url.
if ($_POST) {   
    // INCLUDES CONFIGURATION VARIABLES FOR DATABASE ACCESS
    include('../includes/siteConfig.php');

    // CONNECT TO DATABASE
    $connect = mysql_connect($hostName,$rootName,$dBasePassword) or die ('Unable to connect!');
    mysql_select_db($dBaseName) or die ('Unable to select database!');
    
    // GET VARIABLES VIA POST METHOD
    $origin = $_POST['origin'];
    
    
    // QUERY - GETS ALL DOCUMENTS BASED ON DOCUMENT TYPE
    $query = 
        "
            SELECT mainDocumentId , label, MainDocument.documentSetupId documentSetupId
            FROM MainDocument,Document_Label,Label,DocumentSetup
            WHERE originId = '$origin' AND status = 'Active' 
                  AND mainDocumentId = documentId
                  AND Document_Label.labelId = Label.labelId    
                  AND mainLabel = '1'
                  AND MainDocument.documentSetupId = DocumentSetup.documentSetupId

            Order By label

        ";
    
    $result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
    
    
    // SAVE QUERY RESULTS TO AN ARRAY > $row   
   if (mysql_num_rows($result) > 0){
        while ($row = mysql_fetch_array($result)) {
            $jsondata = array();
            $jsondata['mainDocumentId'] = $row['mainDocumentId'];
            $jsondata['tag'] = $row['label'];
            $jsondata['documentSetupId'] = $row['documentSetupId'];
            $feed[] = $jsondata;
        }
        echo json_encode($feed);
    }
    else{
        echo json_encode(0);
    }

    mysql_free_result($result);
    mysql_close($connect);
}   // End - Checker for those users who will just go to the page by typing directly in the url.
else {
 echo "You are not authorized to view this page. This incident will be reported immediately.";
}
?>